Returns the cumulative interest paid on a loan between the periods startPeriod and endPeriod, based on a given interest rate (relative to one period), the total number of periods nper, the present value pv and payments made in arrears.

=cumIPMT(0.0075, 360, 125000, 13, 24) → -11135.2321307508

Returns the cumulative principal paid on a loan between the periods startPeriod and endPeriod, based on a given interest rate (relative to one period), the total number of periods nper, the present value pv and payments made in arrears.

=cumPRINC(0.0075, 360, 125000, 13, 24) → -934.107123420876

Returns the depreciation of an asset for a given period using the fixed‑declining balance method, where cost is the initial cost of an asset, salvage is the value at the end of the depreciation, life is the total number of depreciation periods, period is the period for which the depreciation is calculated, month is the number of months in the first year. The default value of month is 12.

=db(1000000, 100000, 6, 1, 7) → 185912.959716189
=db(1000000, 100000, 6, 7, 7) → 15867.888384391

Returns the depreciation of an asset for a given period using the double‑declining balance method or other method determined by the optional factor declining rate, where cost is the initial cost of an asset, salvage is the value at the end of the depreciation, life is the total number of depreciation periods, period is the period for which the depreciation is calculated, factor is the rate at which the balance declines. The default value of factor is 2.

=ddb(2400, 300, 3650, 1) → 1.31506849315068
=ddb(2400, 300, 10, 2, 1.5) → 306

Converts a dollar price represented by a fraction with a given denominator value to a decimal number.

=dollarDe(1.02, 16) → 1.125 (=1 2/16)

Converts a decimal number to a dollar price represented by a fraction with a given denominator value.

=dollarFr(1.125, 16) → 1.02 (=1 2/16)

Calculates and returns the annual effective interest rate based on the nominal annual interest rate and the number of compounding periods per year nper.

=effect(5.25%, 4) → 0.05354266737076

Returns the future value of an investment based on constant periodic payments and interest rate where rate is the interest rate (relative to one period), pmt is the periodic payment, pv is the present value of the investment and type specifies the payment type: 0 – at the end of each period, 1 – at the beginning of each period. If pmt is omitted, pv must be specified. If pv is omitted, it is assumed to be 0 and pmt must be specified. The default value of type is 0.

=fv(0.5%, 10, -200, -500, 1) → 2581.40337406014

Returns the future value of an initial principal after the specified number of periods at a variable interest rate in each period. The v_ arguments are numbers or array(s) of numbers representing the subsequent interest rates. Empty cells are treated as zeros.

=fvSchedule(1, {0.09, 0.11, 0.1}) → 1.33089

Returns the interest payment for a given period based on constant periodic payments and a constant interest rate where nper is the total number of periods, pv is the present value or the current value of the future payments, fv is the future value (after the last payment is made) and payments occur at the end of each period. If fv is omitted, it is assumed to be 0.

=ipmt(0.1/12, 1, 36, 8000) → -66.6666666666667

Returns the internal interest rate for a series of (negative and positive) cash flows occurring at regular intervals. The pv(n) arguments can be numbers or arrays of numbers, guess is the value of the rate that irr will use as the initial approximation of the actual rate. Empty cells in arrays are ignored.

=irr(-70000, 12000, 15000, 18000, 21000, 26000, 0%) → 0.08663094803653

Returns the modified internal rate of return for a series of (negative and positive) cash flows assuming that the obtained cash can be reinvested at a given interest rate (relative to one period). Empty cells in arrays are ignored. To evaluate an investment, compare that value with the interest rate paid on the capital.

=mirr({-120000, 39000, 30000, 21000, 37000, 46000}, 12%) → 0.12609413036591

Calculates and returns the annual nominal interest rate, based on a given effective rate and the number of compounding periods per year.

=nominal(5.3543%, 4) → 0.05250031986836

Returns the total number of periods for an investment based on constant periodic payments and a constant interest rate. The pmt argument is the periodic payment, pv is the present value, fv is a cash balance after the last payment is made and type specifies the payment type: 0 – at the end of each period, 1 – at the beginning of each period. If fv is omitted, it is assumed to be 0. The default value of type is 0.

=nper(12%/12, -100, -1000, 10000, 1) → 59.6738656742946
=nper(1%, -100, 1000) → 10.5886444594232

Returns the net present value of an investment, given the rate discount rate and a series of future payments and income occurring at regular intervals in arrears. The rate argument is the discount rate (relative to one period), the v_ values are numbers or arrays of numbers representing payments or income. Empty cells are ignored.

=npv(10%, -10000, 3000, 4200, 6800) → 1188.44341233522

Returns the payment for a loan based on constant payments and constant interest rate. The rate argument is the interest rate, nper is the total number of payment periods, pv the present value, fv is a cash balance after the last payment is made and type specifies the payment type: 0 – at the end of each period, 1 – at the beginning of each period. If fv is omitted, it is assumed to be 0. The default value of type is 0.

=pmt(8%/12, 10, 10000) → -1037.03208935916
=pmt(8%/12, 10, 10000, 0, 1) → -1030.16432717798

Returns the principal portion of a given payment. The rate argument is the interest rate (relative to one period), period is the period that the payment refers to, nper is the total number of periods, pv is the present value, fv is a cash balance after the last payment is made and type specifies the payment type: 0 – at the end of each period, 1 – at the beginning of each period. If fv is omitted, it is assumed to be 0. The default value of type is 0.

=ppmt(10%/12, 1, 24, 2000) → -75.6231860083666

Returns the present value of an investment where rate is the interest rate (relative to one period), nper is the total number of compounding periods, pmt is the periodic payment, fv is the future value and type specifies the payment type: 0 – at the end of each period, 1 – at the beginning of each period. If fv is omitted, it is assumed to be 0. The default value of type is 0.

=pv(0.08/12, 12*20, 500, , 0) → -59777.1458511878

Returns the average interest rate per period. The nper argument is the total number of periods, pmt is the periodic payment, pv is the present value, fv is the future value, type is the payment type: 0 – at the end of each period, 1 – at the beginning of each period. If fv is omitted, it is assumed to be 0. The default value of type is 0.

=rate(48, -200, 8000) → 0.0077014724882

Returns the straight‑line depreciation of an asset for one period. The cost argument is initial value of an asset, salvage is the value at the end of the depreciation, life is the total number of depreciation periods.

=sln(30000, 7500, 10) → 2250

Returns the sum‑of‑years’ digits depreciation of an asset for a given period. The cost argument is the initial value of an asset, salvage is the value at the end of the depreciation period, life is the total number of depreciation periods, period is the period for which the SYD value is calculated.

=syd(30000, 7500, 10, 1) → 4090.909090909

Returns the internal rate of return for a schedule of cash flows without the periodicity constraint. The flows argument is an array of numbers representing cash flows and the dates argument is an array of generic date/time strings indicating when the corresponding cash flows occur. The first element of the flows array is optional and represents the initial cost/investment. The first element of the dates array specifies the beginning of the schedule; the remaining dates can be placed in any order but they must be later than the first one. The guess argument is the value of the rate that xirr will use as the initial approximation of the actual rate. The default value of guess is 10%.

=xirr({-10000, 2750, 4250, 3250, 2750}, {"1992-01-01", "1992-03-01", "1992-10-30", "1993-02-15", "1993-04-01"}, 0.1) → 0.37336253351883

Returns the net present value of an investment for a schedule of cash flows without the periodicity constraint. The rate argument is the discount rate, flows is an array of numbers representing cash flows and the dates argument is an array of generic date/time strings indicating when the corresponding cash flows occur. The first element of the flows array is optional and represents the initial cost/investment. The first element of the dates array specifies the beginning of the schedule; the remaining dates can be placed in any order but they must be later than the first one.

=xnpv(0.09, {-10000, 2750, 4250, 3250, 2750}, {"1992-01-01", "1992-03-01", "1992-10-30", "1993-02-15", "1993-04-01"}) → 2086.64760205153